SELECT doc.docdesc, doc.updatedatetime, CONCAT( pro.last_name, '(',doc.doccreator,')') AS Uploaded_By, dem.last_name, dem.first_name, CONCAT( "", "eChart", "" ) AS "eChart" FROM document doc LEFT JOIN ctl_document ctl ON doc.document_no = ctl.document_no LEFT JOIN demographic dem ON ctl.module_id = dem.demographic_no LEFT JOIN provider pro ON doc.doccreator = pro.provider_no WHERE doc.updatedatetime BETWEEN ('{start_date} 00:00:00') and ('{finish_date} 23:59:59') AND doc.doccreator = IF( '{provider}' = 'ALL', doc.doccreator , IF( '{provider}' = 'NONE', '', '{provider}' )) AND LOCATE( '{searchfor}', doc.docdesc ) > 0 ; ( SELECT provider_no, CONCAT(last_name,',',first_name,'(',provider_no,')') AS name FROM provider ) UNION ( SELECT 'ALL', ' All providers' ) UNION ( SELECT 'NONE', ' No provider' ) ORDER BY name ;